// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   register_picture.java

package hr.file;

import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import include.operateDB.CdefineUpdate;
import java.io.IOException;
import java.net.URL;
import java.sql.ResultSet;
import java.util.*;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;

public class register_picture extends HttpServlet
{

	ServletContext application;
	HttpSession session;
	nseer_db_backup1 erp_db;

	public register_picture()
	{
		erp_db = null;
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			java.io.PrintWriter out = response.getWriter();
			nseer_db_backup1 hr_db = new nseer_db_backup1(dbApplication);
			counter count = new counter(dbApplication);
			if (hr_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				String major_first_kind_ID = "";
				String major_first_kind_name = "";
				String major_second_kind_ID = "";
				String major_second_kind_name = "";
				String salary_standard_ID = "";
				String salary_standard_name = "";
				String salary_sum = "";
				String major_second_kind = request.getParameter("select5");
				String major_first_kind = request.getParameter("select4");
				for (StringTokenizer tokenTO4 = new StringTokenizer(major_first_kind, "/"); tokenTO4.hasMoreTokens();)
				{
					major_first_kind_ID = tokenTO4.nextToken();
					major_first_kind_name = tokenTO4.nextToken();
				}

				for (StringTokenizer tokenTO5 = new StringTokenizer(major_second_kind, "/"); tokenTO5.hasMoreTokens();)
				{
					major_second_kind_ID = tokenTO5.nextToken();
					major_second_kind_name = tokenTO5.nextToken();
				}

				String kind_chain = request.getParameter("kind_chain");
				String chain_id = Divide1.getId(kind_chain);
				String chain_name = Divide1.getName(kind_chain);
				if (!chain_id.equals(""))
				{
					String human_name = request.getParameter("human_name");
					String human_address = request.getParameter("human_address");
					String major_type = request.getParameter("major_type");
					String human_title_class = request.getParameter("human_title_class");
					String salary_standard = request.getParameter("salary_standard");
					for (StringTokenizer tokenTO6 = new StringTokenizer(salary_standard, "/"); tokenTO6.hasMoreTokens();)
					{
						salary_standard_ID = tokenTO6.nextToken();
						salary_standard_name = tokenTO6.nextToken();
						salary_sum = tokenTO6.nextToken();
					}

					String human_bank = request.getParameter("human_bank");
					String human_account = request.getParameter("human_account");
					String human_tel = request.getParameter("human_tel");
					String human_home_tel = request.getParameter("human_home_tel");
					String human_postcode = request.getParameter("human_postcode");
					String register = request.getParameter("register");
					String human_cellphone = request.getParameter("human_cellphone");
					String idcard = request.getParameter("idcard");
					String SIN = request.getParameter("SIN");
					String religion = request.getParameter("religion");
					String party = request.getParameter("party");
					String race = request.getParameter("race");
					String nationality = request.getParameter("nationality");
					String age = request.getParameter("age");
					String sex = request.getParameter("sex");
					String speciality = request.getParameter("speciality");
					String hobby = request.getParameter("hobby");
					String birthday = request.getParameter("birthday");
					if (birthday.equals(""))
						birthday = "1800-01-01";
					String birthplace = request.getParameter("birthplace");
					String human_email = request.getParameter("human_email");
					String educated_degree = request.getParameter("educated_degree");
					String educated_years = request.getParameter("educated_years");
					String educated_major = request.getParameter("educated_major");
					String register_time = request.getParameter("register_time");
					String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
					String remark = exchange.toHtml(bodyc);
					String bodya = new String(request.getParameter("history_records").getBytes("UTF-8"), "UTF-8");
					String history_records = exchange.toHtml(bodya);
					String bodyb = new String(request.getParameter("family_membership").getBytes("UTF-8"), "UTF-8");
					String family_membership = exchange.toHtml(bodyb);
					try
					{
						String human_ID = NseerId.getId(getClass().getResource("").toString(), (String)dbSession.getAttribute("unit_db_name"));
						String sqll = (new StringBuilder("select * from hr_file where human_ID='")).append(human_ID).append("' and human_name='").append(human_name).append("'").toString();
						ResultSet rset = hr_db.executeQuery(sqll);
						if (rset.next())
						{
							response.sendRedirect("hr/file/register_picture_a.jsp");
						} else
						{
							String sql = (new StringBuilder("insert into hr_file(chain_id,chain_name,human_major_first_kind_ID,human_major_first_kind_name,human_major_second_kind_ID,human_major_second_kind_name,human_ID,human_name,human_address,human_title_class,major_type,human_bank,human_account,human_tel,human_home_tel,human_postcode,salary_standard_ID,salary_standard_name,salary_sum,educated_degree,educated_years,educated_major,register,register_time,family_membership,history_records,remark,human_cellphone,idcard,SIN,religion,race,nationality,party,age,birthday,birthplace,sex,speciality,hobby,human_email) values ('")).append(chain_id).append("','").append(chain_name).append("','").append(major_first_kind_ID).append("','").append(major_first_kind_name).append("','").append(major_second_kind_ID).append("','").append(major_second_kind_name).append("','").append(human_ID).append("','").append(human_name).append("','").append(human_address).append("','").append(human_title_class).append("','").append(major_type).append("','").append(human_bank).append("','").append(human_account).append("','").append(human_tel).append("','").append(human_home_tel).append("','").append(human_postcode).append("','").append(salary_standard_ID).append("','").append(salary_standard_name).append("','").append(salary_sum).append("','").append(educated_degree).append("','").append(educated_years).append("','").append(educated_major).append("','").append(register).append("','").append(register_time).append("','").append(family_membership).append("','").append(history_records).append("','").append(remark).append("','").append(human_cellphone).append("','").append(idcard).append("','").append(SIN).append("','").append(religion).append("','").append(race).append("','").append(nationality).append("','").append(party).append("','").append(age).append("','").append(birthday).append("','").append(birthplace).append("','").append(sex).append("','").append(speciality).append("','").append(hobby).append("','").append(human_email).append("')").toString();
							hr_db.executeUpdate(sql);
							CdefineUpdate CdefineUpdate = new CdefineUpdate();
							sql = CdefineUpdate.update("hr_file", "human_ID", human_ID, request);
							hr_db.executeUpdate(sql);
							String sql1 = (new StringBuilder("update hr_config_file_kind set delete_tag='1' where file_id='")).append(chain_id).append("'").toString();
							hr_db.executeUpdate(sql1);
							List rsList = GetWorkflow.getList(hr_db, "hr_config_workflow", "01");
							if (rsList.size() == 0)
							{
								sql = (new StringBuilder("update hr_file set check_tag='1' where human_ID='")).append(human_ID).append("'").toString();
								hr_db.executeUpdate(sql);
							} else
							{
								for (Iterator ite = rsList.iterator(); ite.hasNext(); hr_db.executeUpdate(sql))
								{
									String elem[] = (String[])ite.next();
									sql = (new StringBuilder("insert into hr_workflow(config_id,object_ID,type_id,describe1,describe2) values ('")).append(elem[0]).append("','").append(human_ID).append("','01','").append(elem[1]).append("','").append(elem[2]).append("')").toString();
								}

							}
							response.sendRedirect((new StringBuilder("hr/file/register_choose_picture.jsp?human_ID=")).append(human_ID).toString());
						}
					}
					catch (Exception ex)
					{
						ex.printStackTrace();
					}
				} else
				{
					response.sendRedirect("hr/file/register_picture_b.jsp");
				}
				hr_db.commit();
				hr_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
